EDLD 610 Winter 2020 Final Project
Jim Wright
2/3/2020
Plot 1
Data is ranked in order of median income with the highest incomes at the top of the data set
The purpose of these plots will be to display the distribution of median salaries by college major, by specifically focusing on both the top 20 median salaries and bottom 20 median salaries
## # A tibble: 6 x 21
## rank major_code major total men women major_category share_women
## <int> <int> <chr> <int> <int> <int> <chr> <dbl>
## 1 1 2419 PETR… 2339 2057 282 Engineering 0.121
## 2 2 2416 MINI… 756 679 77 Engineering 0.102
## 3 3 2415 META… 856 725 131 Engineering 0.153
## 4 4 2417 NAVA… 1258 1123 135 Engineering 0.107
## 5 5 2405 CHEM… 32260 21239 11021 Engineering 0.342
## 6 6 2418 NUCL… 2573 2200 373 Engineering 0.145
## # … with 13 more variables: sample_size <int>, employed <int>, full_time <int>,
## # part_time <int>, full_time_year_round <int>, unemployed <int>,
## # unemployment_rate <dbl>, median <int>, p25th <int>, p75th <int>,
## # college_jobs <int>, non_college_jobs <int>, low_wage_jobs <int>## # A tibble: 6 x 9
## rank major_code major major_category total men women share_women median
## <int> <int> <chr> <chr> <int> <int> <int> <dbl> <int>
## 1 1 2419 PETROLEU… Engineering 2339 2057 282 0.121 110000
## 2 2 2416 MINING A… Engineering 756 679 77 0.102 75000
## 3 3 2415 METALLUR… Engineering 856 725 131 0.153 73000
## 4 4 2417 NAVAL AR… Engineering 1258 1123 135 0.107 70000
## 5 5 2418 NUCLEAR … Engineering 2573 2200 373 0.145 65000
## 6 6 2405 CHEMICAL… Engineering 32260 21239 11021 0.342 65000## # A tibble: 173 x 4
## major median p25th p75th
## <chr> <int> <int> <int>
## 1 PETROLEUM ENGINEERING 110000 95000 125000
## 2 MINING AND MINERAL ENGINEERING 75000 55000 90000
## 3 METALLURGICAL ENGINEERING 73000 50000 105000
## 4 NAVAL ARCHITECTURE AND MARINE ENGINEERING 70000 43000 80000
## 5 CHEMICAL ENGINEERING 65000 50000 75000
## 6 NUCLEAR ENGINEERING 65000 50000 102000
## 7 ACTUARIAL SCIENCE 62000 53000 72000
## 8 ASTRONOMY AND ASTROPHYSICS 62000 31500 109000
## 9 MECHANICAL ENGINEERING 60000 48000 70000
## 10 ELECTRICAL ENGINEERING 60000 45000 72000
## # … with 163 more rows
Plot 2
The purpose of Plot 2 will be to communicate visualizations of the recent-grads data to display trends in unemployment rate per college major and major category
## # A tibble: 1 x 1
## `mean(median)`
## <dbl>
## 1 40151.## # A tibble: 1 x 1
## `mean(unemployment_rate_percentage)`
## <dbl>
## 1 0.0682
Plot 3
The purpose of plot 3 will be to use the recent_grads and women_stem data sets to compare trends in the percentage of women working in these fields
## # A tibble: 6 x 21
## rank major_code major total men women major_category share_women
## <int> <int> <chr> <int> <int> <int> <chr> <dbl>
## 1 1 2419 PETR… 2339 2057 282 Engineering 0.121
## 2 2 2416 MINI… 756 679 77 Engineering 0.102
## 3 3 2415 META… 856 725 131 Engineering 0.153
## 4 4 2417 NAVA… 1258 1123 135 Engineering 0.107
## 5 5 2405 CHEM… 32260 21239 11021 Engineering 0.342
## 6 6 2418 NUCL… 2573 2200 373 Engineering 0.145
## # … with 13 more variables: sample_size <int>, employed <int>, full_time <int>,
## # part_time <int>, full_time_year_round <int>, unemployed <int>,
## # unemployment_rate <dbl>, median <int>, p25th <int>, p75th <int>,
## # college_jobs <int>, non_college_jobs <int>, low_wage_jobs <int>## # A tibble: 6 x 9
## rank major_code major major_category total men women share_women median
## <int> <int> <chr> <chr> <int> <int> <int> <dbl> <int>
## 1 1 2419 PETROLEU… Engineering 2339 2057 282 0.121 110000
## 2 2 2416 MINING A… Engineering 756 679 77 0.102 75000
## 3 3 2415 METALLUR… Engineering 856 725 131 0.153 73000
## 4 4 2417 NAVAL AR… Engineering 1258 1123 135 0.107 70000
## 5 5 2418 NUCLEAR … Engineering 2573 2200 373 0.145 65000
## 6 6 2405 CHEMICAL… Engineering 32260 21239 11021 0.342 65000
| STEM Major Statistics | |||
|---|---|---|---|
| College Major | Median Salary | Percent Women Employed | Percent Men Employed |
| Engineering | |||
| BIOMEDICAL ENGINEERING | $60,000.00 | 44% | 56% |
| ARCHITECTURE | $40,000.00 | 45% | 55% |
| MINING AND MINERAL ENGINEERING | $75,000.00 | 10% | 90% |
| MECHANICAL ENGINEERING RELATED TECHNOLOGIES | $40,000.00 | 8% | 92% |
| Physical Sciences | |||
| NUCLEAR, INDUSTRIAL RADIOLOGY, AND BIOLOGICAL TECHNOLOGIES | $46,000.00 | 75% | 25% |
| OCEANOGRAPHY | $44,700.00 | 69% | 31% |
| PHYSICS | $45,000.00 | 28% | 72% |
| ATMOSPHERIC SCIENCES AND METEOROLOGY | $35,000.00 | 32% | 68% |
| Computers & Mathematics | |||
| MATHEMATICS | $45,000.00 | 45% | 55% |
| STATISTICS AND DECISION SCIENCE | $45,000.00 | 53% | 47% |
| MATHEMATICS AND COMPUTER SCIENCE | $42,000.00 | 18% | 82% |
| COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY | $37,500.00 | 18% | 82% |
| Biology & Life Science | |||
| PHARMACOLOGY | $45,000.00 | 71% | 29% |
| NEUROSCIENCE | $35,000.00 | 64% | 36% |
| GENETICS | $40,000.00 | 52% | 48% |
| BIOCHEMICAL SCIENCES | $37,400.00 | 52% | 48% |
| Health | |||
| MEDICAL ASSISTING SERVICES | $42,000.00 | 93% | 7% |
| COMMUNICATION DISORDERS SCIENCES AND SERVICES | $28,000.00 | 97% | 3% |
| PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTRATION | $40,000.00 | 63% | 37% |
| HEALTH AND MEDICAL PREPARATORY PROGRAMS | $33,500.00 | 57% | 43% |
| Data from fivethirtyeight | |||